<%-- 
    Document   : allresult
    Created on : Apr 23, 2012, 3:38:21 PM
    Author     : project
--%>


<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn" %>
<%@include file="header.jsp" %>
<%try{

   Connection con=Dbconn.getConn();
   Statement st=con.createStatement();
   String   sql="SELECT jobs.walkindate,jobs.jobtitle,registrationno,jobs.compid,company.compname,student.username,name  FROM student inner join job_applied on student.username=job_applied.username inner join  college on college.clgid=student.clgid inner join jobs on jobs.jobid=job_applied.jobid inner join company on company.compid=jobs.compid where  job_applied.result='pass' and college.clgid='"+session.getAttribute("username")+"' ";
   ResultSet rs=st.executeQuery(sql);
%>


<table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td align="left" valign="top">

            <span class='messagesred' style="text-align:center">
            </span>

            <table width="100%" border="0" cellspacing="0" >
                <tr>
                    <td width="100%" align="left" valign="top"><span class="mainheading_emp" style="margin-bottom:10px;"> List of All Successful Candidates</span></td>
                </tr>
                <tr>
                    <td height="10" align="right" valign="middle" class="normal">
					
                        <a href="CollegeResultAll?clgid=<%=session.getAttribute("username")%>" target="_blank">
                                                    <input type="button" class="button2" value="View/Print Report" />
                                                </a>
					
					</td>
                </tr>
                <tr>
                    <td height="26" align="center" valign="top" class="normal">
                        <table width="100%" border="0" cellspacing="2"  class="tbl_bdr">
                            <tr class="sde_mnu_hdr_blue" style="color:#000066;font-weight:bold" align="center" >
                                <td width="35" height="40" align="center" valign="middle" class="subjeading" style="background-color: skyblue">#</td>
                                <td width="113" valign="middle" class="subjeading" style="background-color: skyblue">Photo</td>
                                <td width="249" valign="middle" class="subjeading" style="background-color: skyblue">Regno</td>
                              <td width="249" valign="middle" class="subjeading" style="background-color: skyblue"> Name</td>
                              <td width="205" valign="middle" class="subjeading" style="background-color: skyblue">Job Title</td>
                              <td width="163" valign="middle" class="subjeading" style="background-color: skyblue">Walkindate</td>
                              <td width="213" valign="middle" class="subjeading" style="background-color: skyblue">Company</td>
                          </tr>

                             <%
                                int i=0;
                                while (rs.next()) { i++;
                             %>
                            <tr class="greybg" style="font-weight:bold" align="center">
                                <td rowspan="2" align="center" valign="middle"><%=i%></td>
                                <td rowspan="2" valign="middle"><img src="../src/getpic.jsp?id=<%=rs.getString("username")%>&table=student&col=photo&pk_col=username" width="72" height="71" border="0" /></td>
                                <td rowspan="2"  valign="middle"><%= rs.getString("registrationno")%></td>
                                <td rowspan="2"  valign="middle"><%= rs.getString("name")%></td>
                                <td rowspan="2"  valign="middle"><%=rs.getString("jobtitle")%></td>
                                <td rowspan="2"  valign="middle"><%=rs.getString("walkindate")%></td>
                                <td  valign="middle">
                          <img src="../src/getpic.jsp?id=<%=rs.getString("jobs.compid")%>&table=company&col=logo&pk_col=compid" width="105" height="50" border="0" />                           </tr>
                            <tr class="greybg" style="font-weight:bold" align="center">
                              <td height="33"  valign="middle"><font color='black'><%= rs.getString("compname") %></font>                          </tr>

<%}%>

              <tr align="center">
                 <td width="35" height="30" align="center" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="113"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="249"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="249"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="205"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="163"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="213"  valign="middle" class="subjeading" style="background-color: skyblue">&nbsp;</td>
                          </tr>
                  </table></td>
                </tr>
            </table></td>
    </tr>
</table>
<%}catch(Exception e){
out.println("<font color=\"black\">"+e+"</font>");
}%>
<a href="http://apycom.com/"></a>